package com.coupons.business.category.dao;

import java.util.List;

import com.coupons.business.common.exception.BaseCouponsAppException;
import com.coupons.business.common.vo.Category;

public interface ICategoryDAO 
{
	public void createCategory(Category objaCategory) throws BaseCouponsAppException;
	public void updateCategory (Category objaCategory) throws BaseCouponsAppException;
	public Category getCategory(int CategoryId) throws BaseCouponsAppException;
	public List<Category> getAllCategorys(int partnerId, int merchantId)throws BaseCouponsAppException ;
	
	public String CATEGORY_INSERT_STATEMENT = "INSERT INTO CATEGORY(CTGRY_ID,CTGRY_NAME,MRCHNT_ID,PARTNER_ID,DESCRIPTION," +
											  "STATUS,LAST_UPDT_USER,RANK,CRTN_DT,LAST_UPDT_DT) VALUES(?,?,?,?,?,?,?,?,SYSDATE,SYSDATE)";
	
	public String CATEGORY_UPDATE_STATEMENT = "UPDATE CATEGORY SET CTGRY_NAME = ?, DESCRIPTION = ?, " +
											  "STATUS=?,RANK=?, " + "LAST_UPDT_USER=?, LAST_UPDT_DT=SYSDATE WHERE CTGRY_ID = ?";
	
	public String SEQUENCE_NAME="CATEGORY_SQ";
	
	public String GET_ALL_CATEGORYS_STATEMENT = "SELECT *  FROM CATEGORY where PARTNER_ID =? AND MRCHNT_ID=? ";
	
	public String GET_CATEGORY_STATEMENT = "SELECT * FROM CATEGORY where CTGRY_ID = ?";
}
